Use RD_Common
go

CREATE NONCLUSTERED INDEX [R&G EX Price and LBS-Foodservice_DTA_041912_K1_K57_K14] ON [dbo].[Star_Dates]
(
	[Dates] ASC,
	[CompanyDateID] ASC,
	[FiscalMonth] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

Use RD_CommonWork
go

CREATE NONCLUSTERED INDEX [R&G EX Price and LBS-Foodservice_DTA_041912_K1_2_5_6_7_8] ON [dbo].[ITEM_SUPPLEMENTAL]
(
	[ITEMNUMBERID] ASC
)
INCLUDE ( [SOURCEID],
[L1_FINISHED_GOODS_CODE],
[L1_FINISHED_GOODS],
[L2_FINISHED_GOODS_CODE],
[L2_FINISHED_GOODS]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

Use RD_SalesMart
go

CREATE NONCLUSTERED INDEX [R&G EX Price and LBS-Foodservice_DTA_041912_K56_K25] ON [dbo].[Sales_Star_Facts]
(
	[UnitOfMeasureAsInput] ASC,
	[ItemNumber] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [R&G EX Price and LBS-Foodservice_DTA_041912_K10_K7_K1] ON [dbo].[Sales_Star_FactsExt]
(
	[TransactionType] ASC,
	[OrderTypeCode] ASC,
	[FactsExtID] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
